Exam Ref 70-778 Analyzing and Visualizing Data by Using Microsoft Power BI by Daniil Maslyuk

Author:Daniil Maslyuk [Maslyuk, Daniil]
Language: eng
Format: epub
Publisher: Pearson Education
Published: 2018-06-11T23:00:00+00:00

Value

1/05/2018 12:00:00 AM

1/05/2018 12:00:00 PM

2/05/2018 12:00:00 AM

2/05/2018 12:00:00 PM

3/05/2018 12:00:00 AM

Though GENERATESERIES can only generate numeric or datetime value lists, it is possible to generate lists of letters by combining SELECTCOLUMNS and UNICHAR:

Click here to view code image

Uppercase Latin alphabet: = SELECTCOLUMNS ( GENERATESERIES ( 65, 90 ), "Letter", UNICHAR ( [Value] ) )

Letter

A

B

C

…

Z

NOTE USING THE UNICHAR FUNCTION

The UNICHAR function takes a positive integer as its only parameter and returns a Unicode character with the code. A list of Unicode characters and their corresponding decimal numbers can be found online on websites such as Wikipedia at: https://en.wikipedia.org/wiki/List_of_Unicode_characters.

For more examples of using the function, see Chris Webb’s blog post, “The DAX Unichar() Function And How To Use It In Measures For Data Visualization” at https://blog.crossjoin.co.uk/2017/04/11/the-dax-unichar-function-and-how-to-use-it-in-measures-for-data-visualisation/.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.